<?php

/**
 * This is the model class for table "tbl_jobs_documents".
 *
 * The followings are the available columns in table 'tbl_jobs_documents':
 * @property integer $id
 * @property string $docname
 * @property string $filename
 * @property string $dateadded
 * @property string $addedby 
 * @property string $notes
 * @property string $locktime
 * @property string $lockby
 */
class JobsDocuments extends CActiveRecord
{
    public $file;
	/**
	 * Returns the static model of the specified AR class.
	 * @return JobsDocuments the static model class
	 */
	public static function model($className=__CLASS__)
	{
		return parent::model($className);
	}

	/**
	 * @return string the associated database table name
	 */
	public function tableName()
	{
		return 'tbl_jobs_documents';
	}

	/**
	 * @return array validation rules for model attributes.
	 */
	public function rules()
	{
		// NOTE: you should only define rules for those attributes that
		// will receive user inputs.
		return array(
			array('filename,jobid, notes', 'required'),
			array('docname', 'length', 'max'=>150),
			array('filename, addedby', 'length', 'max'=>255),
			
			array('locktime', 'length', 'max'=>20),
			array('lockby', 'length', 'max'=>30),
                 
			// The following rule is used by search().
			// Please remove those attributes that should not be searched.
			
		);
	}

	/**
	 * @return array relational rules.
	 */
	public function relations()
	{
		// NOTE: you may need to adjust the relation name and the related
		// class name for the relations automatically generated below.
		return array(
		);
	}

	/**
	 * @return array customized attribute labels (name=>label)
	 */
	public function attributeLabels()
	{
		return array(
			'id' => 'ID',
			'docname' => 'Docname',
			'filename' => 'Filename',
			'dateadded' => 'Dateadded',
			'addedby' => 'Addedby',
			'custno' => 'Custno',
			'locno' => 'Locno',
			'notes' => 'Notes',
			'dispatch' => 'Dispatch',
			'locktime' => 'Locktime',
			'lockby' => 'Lockby',
		);
	}

	/**
	 * Retrieves a list of models based on the current search/filter conditions.
	 * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
	 */
	public function search()
	{
		// Warning: Please modify the following code to remove attributes that
		// should not be searched.

		$criteria=new CDbCriteria;

		$criteria->compare('id',$this->id);
		$criteria->compare('docname',$this->docname,true);
		$criteria->compare('filename',$this->filename,true);
		$criteria->compare('dateadded',$this->dateadded,true);
		$criteria->compare('addedby',$this->addedby,true);
		$criteria->compare('custno',$this->custno,true);
		$criteria->compare('locno',$this->locno,true);
		$criteria->compare('notes',$this->notes,true);
		$criteria->compare('dispatch',$this->dispatch,true);
		$criteria->compare('locktime',$this->locktime,true);
		$criteria->compare('lockby',$this->lockby,true);

		return new CActiveDataProvider($this, array(
			'criteria'=>$criteria,
		));
	}
        public function beforeSave() {      
            
            
            if($this->isNewRecord){
                $this->dateadded = DateUtil::getDefaultCurrentDateTime();
                $this->addedby=Yii::app()->user->name;
            }

          
            return parent::beforeSave();


        }
        public function beforeDelete() {
            if($this->filename!=NULL){
                if(file_exists('documents/'.$this->filename)){
                    unlink('documents/'.$this->filename);
                }
            }
            return parent::beforeDelete();
        }
     
}
